/**
 * 
 */
package com.ttl.ittl.view;

/**
 *  @author :  Surasak Lekmart
 *  Created :  30 May 2012 11:27:22 
 *  Project :  ittl
 */
public class ViewITTL_Pack {

	/** 
	 *  DataBase : TTL51
	 *     Table : -
	 *      View : ViewITTL_Pack
	 *  Descript.:
	 *  
	 *  SELECT     p.itemCode, i.name1 AS itemName, p.packSize, i.orderPoint, i.stockMin, i.stockMax, v.barcode, v.barcodeName
	 *  FROM         ittl_pack p, bcitem i, view_barcode_master v
	 *  WHERE     p.itemCode = i.code
	 *  and p.itemCode = v.itemCode
	 *  UNION
	 *  SELECT     i.code, i.name1, 0, orderPoint, stockMin, stockMax, v.barcode, v.barcodeName
	 *  FROM         bcitem i,view_barcode_master v
	 *  WHERE i.Code = v.itemCode
	 *  and    (Code LIKE '2-%' OR
	 *                        Code LIKE '3-%') AND Code NOT IN
 	 *                           (SELECT     itemCode
	 *                              FROM          ittl_pack)
	 *  
	 */
	private	String	itemCode;
	private	String	itemName;
	private	Float	packSize;
	private	Float	orderPoint;
	private	Float	stockMin;
	private	Float	stockMax;
	private	String	barcode;
	private	String	barcodeName;
	public ViewITTL_Pack() {
	}
	public String getItemCode() {
		return itemCode;
	}
	public void setItemCode(String itemCode) {
		this.itemCode = itemCode;
	}
	public String getItemName() {
		return itemName;
	}
	public void setItemName(String itemName) {
		this.itemName = itemName;
	}
	public Float getPackSize() {
		return packSize;
	}
	public void setPackSize(Float packSize) {
		this.packSize = packSize;
	}
	public Float getOrderPoint() {
		return orderPoint;
	}
	public void setOrderPoint(Float orderPoint) {
		this.orderPoint = orderPoint;
	}
	public Float getStockMin() {
		return stockMin;
	}
	public void setStockMin(Float stockMin) {
		this.stockMin = stockMin;
	}
	public Float getStockMax() {
		return stockMax;
	}
	public void setStockMax(Float stockMax) {
		this.stockMax = stockMax;
	}
	public String getBarcode() {
		return barcode;
	}
	public void setBarcode(String barcode) {
		this.barcode = barcode;
	}
	public String getBarcodeName() {
		return barcodeName;
	}
	public void setBarcodeName(String barcodeName) {
		this.barcodeName = barcodeName;
	}
	
}
